Creating calculated column. 10
Before you start with you measures please make sure you created all calculated column you need for this project the reason I am saying this I had experience with trying sort column after I had a bit challenge so make sure you created your calculated column before
To create calculated
A . On power bi ribbon
you will see Transform Data click on that and another power Query window will appear
Then select created column. Once you done that on power bi ribbon select add column see the screenshot below
Select column from example there will be a dropdown choose from selection see the screenshot below
1. Week of Year On the highlighted area type
week then choose Week of the year created. And then ok.
2. Start of Week select created and the add.
column form example then from selection and type week and you will see Start of
the week form created select and then ok.
3. End of Week select created and then column
form example and from selection and then type week select End of the week from created. and then close and apply.
see gif below
you should able to see this after you closed and apply